create table uri_diary(
	diary_no number primary key,
	d_date date not null,
	d_content varchar2(1000) not null,
	d_id varchar2(50) not null,
	orgfilename varchar2(500),
	newfilename varchar2(500),
	constraint diary_fk_d_id foreign key(d_id) references uri_member(m_id) on delete cascade
)

drop table uri_diary

create sequence diary_no_seq;
drop sequence diary_no_seq;
insert into uri_diary(diary_no,d_date,d_content,d_id) values(diary_no_seq.nextval,sysdate,'오늘의 다이어리 내용입니다. 일기장처럼 사용해도 됩니다^^','java');

